USE [dbdata]
ALTER USER sms WITH LOGIN = sms;
GO
/****** Object:  Role [Browser]    Script Date: 05/13/2012 16:57:06 ******/
CREATE ROLE [Browser] AUTHORIZATION [dbo]
GO

use dbdata
GRANT SELECT ON [dbo].[phones] TO [Browser] 
GRANT SELECT ON [dbo].[accounts] TO [Browser] 
GRANT SELECT ON [dbo].[account_categs] TO [Browser] 
GRANT SELECT ON [dbo].[identificators] TO [Browser] 
GRANT SELECT ON [dbo].[identificator_sets] TO [Browser] 
GRANT SELECT ON [dbo].[users] TO [Browser] 
GO
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'Technosite'

